/*
 Navicat Premium Data Transfer

 Source Server         : sql server
 Source Server Type    : SQL Server
 Source Server Version : 16001135 (16.00.1135)
 Source Catalog        : Graduate Admission System
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001135 (16.00.1135)
 File Encoding         : 65001

 Date: 06/12/2024 21:52:34
*/


-- ----------------------------
-- Table structure for 招生信息表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[招生信息表]') AND type IN ('U'))
	DROP TABLE [dbo].[招生信息表]
GO

CREATE TABLE [dbo].[招生信息表] (
  [subjectid] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [subjectdirection] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [instructorname] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [subjectexam] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [subjectretest] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [annualquota] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [extraquota] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [year] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [eligible] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [instructorid] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[招生信息表] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of 招生信息表
-- ----------------------------
INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'司马睿辰', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'001')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'上官浩宇', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'002')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'南宫瑾瑜', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'003')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'诸葛景轩', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'004')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'欧阳梓涵', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'005')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'西门子轩', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'006')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'东方晨曦', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'007')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'北冥昊天', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'008')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'慕容辰逸', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'009')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'皇甫浩然', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'010')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'欧阳辰宇', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'011')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'司马天佑', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'012')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'上官文轩', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'013')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'南宫晓晨', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'014')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'诸葛明轩', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'015')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'欧阳浩宇', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'016')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'西门昊天', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'017')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'东方瑾瑜', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'018')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'北冥景轩', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'019')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'慕容子轩', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'020')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'皇甫梓涵', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'021')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'欧阳辰逸', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'022')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'司马浩然', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'023')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'上官昊天', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'024')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'南宫明轩', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'025')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'诸葛浩宇', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'026')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'欧阳梓轩', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'027')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'081200', N'计算机科学与技术', N'西门瑾瑜', N'计算机基础', N'算法设计', N'15', N'3', N'2024', N'是', N'028')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'085400', N'电子信息', N'东方景轩', N'电子技术', N'通信原理', N'12', N'2', N'2024', N'是', N'029')
GO

INSERT INTO [dbo].[招生信息表] ([subjectid], [subjectdirection], [instructorname], [subjectexam], [subjectretest], [annualquota], [extraquota], [year], [eligible], [instructorid]) VALUES (N'095400', N'林学', N'北冥辰逸', N'林学基础', N'林学专题', N'10', N'2', N'2024', N'是', N'030')
GO


-- ----------------------------
-- Foreign Keys structure for table 招生信息表
-- ----------------------------
ALTER TABLE [dbo].[招生信息表] ADD CONSTRAINT [FK_招生信息表_学科信息表] FOREIGN KEY ([subjectid]) REFERENCES [dbo].[学科信息表] ([subjectid]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[招生信息表] ADD CONSTRAINT [FK_招生信息表_导师信息表1] FOREIGN KEY ([instructorid]) REFERENCES [dbo].[导师信息表] ([instructorid]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

